Columns
Grants
Dependencies
Details
Triggers
Errors
Columns
Grants
Dependencies
Details
Triggers
Errors
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS | INSERTABLE | UPDATABLE | DELETABLE |
---|---|---|---|---|---|---|---|---|
SID | NUMBER(38) | Yes | null | 1 | null | NO | NO | NO |
OBJ | VARCHAR2(20) | Yes | null | 2 | null | NO | NO | NO |
ID | VARCHAR2(100) | Yes | null | 3 | null | NO | NO | NO |
TITLE | VARCHAR2(100) | Yes | null | 4 | null | NO | NO | NO |
ACTIVITY_DATE | DATE | Yes | null | 5 | null | NO | NO | NO |
OBJ_TYPE | VARCHAR2(100) | Yes | null | 6 | null | NO | NO | NO |
LEAD | VARCHAR2(400) | Yes | null | 7 | null | NO | NO | NO |
OWNING_UNIT | VARCHAR2(400) | Yes | null | 8 | null | NO | NO | NO |
STATUS | VARCHAR2(100) | Yes | null | 9 | null | NO | NO | NO |
SUPPORT_PERSONNEL | VARCHAR2(400) | Yes | null | 10 | null | NO | NO | NO |
ATTACH_CNT | NUMBER | Yes | null | 11 | null | NO | NO | NO |
NOTE_CNT | NUMBER | Yes | null | 12 | null | NO | NO | NO |
PARTIC_CNT | NUMBER | Yes | null | 13 | null | NO | NO | NO |
NBR_ASSOC | NUMBER | Yes | null | 14 | null | NO | NO | NO |
CLOSED_ON | DATE | Yes | null | 15 | null | NO | NO | NO |
CREATED_ON | DATE | Yes | null | 16 | null | NO | NO | NO |
PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
---|
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|
References
NAME | VALUE |
---|---|
CREATED | 18-OCT-24 |
LAST_DDL_TIME | 05-FEB-25 |
OWNER | QART |
VIEW_NAME | V_ALL_INACTIVE_ACTIVITIES |
TEXT_LENGTH | 3719 |
TEXT | WITH all_inactive_activities AS ( SELECT rc.SID, rc.OBJ, rc.ID, rc.TITLE, rc.ACTIVITY_DATE, ot.display OBJ_TYPE FROM MV_A_RECORDS_CHECK rc inner join mv_acm_obj o on rc.obj = o.sid inner join mv_acm_obj_type ot on o.obj_type = ot.sid UNION ALL SELECT p.SID, p.OBJ, p.ID, p.TITLE, p.ACTIVITY_DATE, ot.display OBJ_TYPE FROM MV_A_PSYCH p inner join mv_acm_obj o on p.obj = o.sid inner join mv_acm_obj_type ot on o.obj_type = ot.sid UNION ALL SELECT a.SID, a.OBJ, a.ID, a.TITLE, a.ACTIVITY_DATE, ot.display OBJ_TYPE FROM MV_A_ADVANCEMENT a inner join mv_acm_obj o on a.obj = o.sid inner join mv_acm_obj_type ot on o.obj_type = ot.sid UNION ALL SELECT ci.SID, ci.OBJ, ci.ID, ci.TITLE, ci.ACTIVITY_DATE, ot.display OBJ_TYPE FROM MV_A_COMP_INTRUSION ci inner join mv_acm_obj o on ci.obj = o.sid inner join mv_acm_obj_type ot on o.obj_type = ot.sid UNION ALL SELECT i.SID, i.OBJ, i.ID, i.TITLE, i.ACTIVITY_DATE, ot.display OBJ_TYPE FROM MV_A_INTERVIEW i inner join mv_acm_obj o on i.obj = o.sid inner join mv_acm_obj_type ot on o.obj_type = ot.sid where ot.active = 'N' UNION ALL SELECT d.SID, d.OBJ, d.ID, d.TITLE, d.ACTIVITY_DATE, ot.display OBJ_TYPE FROM MV_A_DEVELOPMENT d inner join mv_acm_obj o on d.obj = o.sid inner join mv_acm_obj_type ot on o.obj_type = ot.sid UNION ALL SELECT dc.SID, dc.OBJ, dc.ID, dc.TITLE, dc.REVIEW_DATE, ot.display OBJ_TYPE FROM MV_A_DATABASE_CHECK dc inner join mv_acm_obj o on dc.obj = o.sid inner join mv_acm_obj_type ot on o.obj_type = ot.sid ), tab_attach_cnt AS ( SELECT obj, COUNT(SID) as cnt from mv_acm_attachment GROUP BY obj ), tab_note_cnt AS ( SELECT obj, COUNT(SID) as cnt from mv_acm_note GROUP BY obj ), tab_partic_cnt AS ( SELECT obj, COUNT(SID) as cnt from mv_partic_involvement GROUP BY obj ), tab_curr_status AS ( Select obj, status from v_obj_status_history where completed_on is null ), tab_closed_on AS ( Select obj, started_on as closed_on from v_obj_status_history where code = 'CLOSED' ), tab_assoc_cnt As ( select obj, sum(cnt) as nbr_assoc from ( select from_obj as obj, count(sid)as cnt from mv_acm_association group by from_obj union all select to_obj as obj, count(sid) as cnt from mv_acm_association group by to_obj ) group by obj ) Select ia.SID, ia.OBJ, ia.ID, ia.TITLE, ia.ACTIVITY_DATE, ia.OBJ_TYPE, lp.sh_display lead, ou.sh_display owning_unit, cs.status, so.sh_display support_personnel, case when ac.cnt is not null then ac.cnt else 0 end as attach_cnt, case when nc.cnt is not null then nc.cnt else 0 end as note_cnt, case when pc.cnt is not null then pc.cnt else 0 end as partic_cnt, case when assc.nbr_assoc is not null then assc.nbr_assoc else 0 end as nbr_assoc, c.closed_on, o.created_on From all_inactive_activities ia inner join mv_acm_obj o on ia.obj = o.sid inner join v_curr_obj_lead_pers lp on ia.obj = lp.obj inner join v_curr_obj_owning_unit ou on ia.obj = ou.obj inner join tab_curr_status cs on ia.obj = cs.obj left outer join v_curr_obj_support_officer so on ia.obj = so.obj left outer join tab_attach_cnt ac on ia.obj = ac.obj left outer join tab_note_cnt nc on ia.obj = nc.obj left outer join tab_partic_cnt pc on ia.obj = pc.obj left outer join tab_assoc_cnt assc on ia.obj = assc.obj left outer join tab_closed_on c on ia.obj = c.obj |
TEXT_VC | WITH all_inactive_activities AS ( SELECT rc.SID, rc.OBJ, rc.ID, rc.TITLE, rc.ACTIVITY_DATE, ot.display OBJ_TYPE FROM MV_A_RECORDS_CHECK rc inner join mv_acm_obj o on rc.obj = o.sid inner join mv_acm_obj_type ot on o.obj_type = ot.sid UNION ALL SELECT p.SID, p.OBJ, p.ID, p.TITLE, p.ACTIVITY_DATE, ot.display OBJ_TYPE FROM MV_A_PSYCH p inner join mv_acm_obj o on p.obj = o.sid inner join mv_acm_obj_type ot on o.obj_type = ot.sid UNION ALL SELECT a.SID, a.OBJ, a.ID, a.TITLE, a.ACTIVITY_DATE, ot.display OBJ_TYPE FROM MV_A_ADVANCEMENT a inner join mv_acm_obj o on a.obj = o.sid inner join mv_acm_obj_type ot on o.obj_type = ot.sid UNION ALL SELECT ci.SID, ci.OBJ, ci.ID, ci.TITLE, ci.ACTIVITY_DATE, ot.display OBJ_TYPE FROM MV_A_COMP_INTRUSION ci inner join mv_acm_obj o on ci.obj = o.sid inner join mv_acm_obj_type ot on o.obj_type = ot.sid UNION ALL SELECT i.SID, i.OBJ, i.ID, i.TITLE, i.ACTIVITY_DATE, ot.display OBJ_TYPE FROM MV_A_INTERVIEW i inner join mv_acm_obj o on i.obj = o.sid inner join mv_acm_obj_type ot on o.obj_type = ot.sid where ot.active = 'N' UNION ALL SELECT d.SID, d.OBJ, d.ID, d.TITLE, d.ACTIVITY_DATE, ot.display OBJ_TYPE FROM MV_A_DEVELOPMENT d inner join mv_acm_obj o on d.obj = o.sid inner join mv_acm_obj_type ot on o.obj_type = ot.sid UNION ALL SELECT dc.SID, dc.OBJ, dc.ID, dc.TITLE, dc.REVIEW_DATE, ot.display OBJ_TYPE FROM MV_A_DATABASE_CHECK dc inner join mv_acm_obj o on dc.obj = o.sid inner join mv_acm_obj_type ot on o.obj_type = ot.sid ), tab_attach_cnt AS ( SELECT obj, COUNT(SID) as cnt from mv_acm_attachment GROUP BY obj ), tab_note_cnt AS ( SELECT obj, COUNT(SID) as cnt from mv_acm_note GROUP BY obj ), tab_partic_cnt AS ( SELECT obj, COUNT(SID) as cnt from mv_partic_involvement GROUP BY obj ), tab_curr_status AS ( Select obj, status from v_obj_status_history where completed_on is null ), tab_closed_on AS ( Select obj, started_on as closed_on from v_obj_status_history where code = 'CLOSED' ), tab_assoc_cnt As ( select obj, sum(cnt) as nbr_assoc from ( select from_obj as obj, count(sid)as cnt from mv_acm_association group by from_obj union all select to_obj as obj, count(sid) as cnt from mv_acm_association group by to_obj ) group by obj ) Select ia.SID, ia.OBJ, ia.ID, ia.TITLE, ia.ACTIVITY_DATE, ia.OBJ_TYPE, lp.sh_display lead, ou.sh_display owning_unit, cs.status, so.sh_display support_personnel, case when ac.cnt is not null then ac.cnt else 0 end as attach_cnt, case when nc.cnt is not null then nc.cnt else 0 end as note_cnt, case when pc.cnt is not null then pc.cnt else 0 end as partic_cnt, case when assc.nbr_assoc is not null then assc.nbr_assoc else 0 end as nbr_assoc, c.closed_on, o.created_on From all_inactive_activities ia inner join mv_acm_obj o on ia.obj = o.sid inner join v_curr_obj_lead_pers lp on ia.obj = lp.obj inner join v_curr_obj_owning_unit ou on ia.obj = ou.obj inner join tab_curr_status cs on ia.obj = cs.obj left outer join v_curr_obj_support_officer so on ia.obj = so.obj left outer join tab_attach_cnt ac on ia.obj = ac.obj left outer join tab_note_cnt nc on ia.obj = nc.obj left outer join tab_partic_cnt pc on ia.obj = pc.obj left outer join tab_assoc_cnt assc on ia.obj = assc.obj left outer join tab_closed_on c on ia.obj = c.obj |
TYPE_TEXT_LENGTH | null |
TYPE_TEXT | null |
OID_TEXT_LENGTH | null |
OID_TEXT | null |
VIEW_TYPE_OWNER | null |
VIEW_TYPE | null |
SUPERVIEW_NAME | null |
EDITIONING_VIEW | N |
READ_ONLY | N |
CONTAINER_DATA | N |
BEQUEATH | DEFINER |
ORIGIN_CON_ID | 16 |
DEFAULT_COLLATION | USING_NLS_COMP |
CONTAINERS_DEFAULT | NO |
CONTAINER_MAP | NO |
EXTENDED_DATA_LINK | NO |
EXTENDED_DATA_LINK_MAP | NO |
HAS_SENSITIVE_COLUMN | NO |
ADMIT_NULL | NO |
PDB_LOCAL_ONLY | NO |
DUPLICATED | N |
SHARDED | N |
OWNER | TRIGGER_NAME | TRIGGER_TYPE | TRIGGERING_EVENT | STATUS | OBJECT_ID |
---|
ATTRIBUTE | Line:Position | TEXT |
---|